package com.zygh.policeasset.mapper;

import com.zygh.policeasset.pojo.QrCodeAluminum;
import com.zygh.policeasset.pojo.vo.QrCodeAluminumVO;
import java.util.List;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

@Mapper
/* loaded from: police-asset-2.0-0.0.1-SNAPSHOT.jar:BOOT-INF/classes/com/zygh/policeasset/mapper/QrCodeAluminumMapper.class */
public interface QrCodeAluminumMapper {
    @Insert({"insert into qr_code_aluminum(create_time,counter,user_id,remark) values(#{createTime},#{counter},#{userId},#{remark})"})
    @Options(useGeneratedKeys = true, keyProperty = "id", keyColumn = "id")
    Integer add(QrCodeAluminum qrCodeAluminum);

    @Delete({"delete from qr_code_aluminum where id = #{id}"})
    Integer deleteById(Integer num);

    @Select({"<script>select pca.*,u.name as userName from qr_code_aluminum pca left join user u on pca.user_id = u.id </script>"})
    @Results({@Result(property = "createTime", column = "create_time")})
    List<QrCodeAluminumVO> selectList();
}